CREATE TABLE Reference (
  id        INT      IDENTITY PRIMARY KEY,
  memb___id VARCHAR(12) NOT NULL,
  active    TINYINT  DEFAULT (1),
  views     INT      DEFAULT (0),
  register  INT      DEFAULT (0),
  data      DATETIME DEFAULT getdate()
);

CREATE TABLE ReferenceRegister (
  id            INT IDENTITY PRIMARY KEY,
  memb___id     VARCHAR(12) NOT NULL,
  memb___id_ref VARCHAR(12) NOT NULL,
  data_register DATETIME
);

CREATE TABLE ReferencePremium (
  id            INT      IDENTITY PRIMARY KEY,
  memb___id     VARCHAR(12)     NOT NULL,
  memb___id_ref VARCHAR(255)    NOT NULL,
  type          VARCHAR(255)    NOT NULL,
  value         INT DEFAULT (0) NOT NULL,
  data          DATETIME DEFAULT getdate()
);